﻿CREATE PROCEDURE [dbo].[AddMilestone]
@ProjectID INT, @TargetDate DATETIME, @Description VARCHAR (500), @DollarAmount MONEY
AS
INSERT INTO Milestones(
				ProjectID,
				TargetDate,
				Description,
				DollarAmount	
			)
VALUES		(
				@ProjectID,
				@TargetDate,
				@Description,
				@DollarAmount	
			)
			
SELECT @@IDENTITY


